BQ Mate 설명글
- 현재 작동하지 않는 기능도 있습니다
BigQuery Mate
Companion tool for BigQuery UI used by myself and my peers at Viant Inc.
(Vindico, Specific Media, Myspace, Xumo). It adds some functionality
to BigQuery Native UI that is found helpful in day on day activity.
BigQuery Mate Features: (see Help for details)
- Control Nav Panel size - retired on Jan.31, 2016
- Hide/Show Datasets Panel
- Datasets Filtering
- Datasets Count (Filtered/Total)
- Monetary Cost estimation based on processed bytes
- Keywords Auto-Capitalization
- Comment/Uncomment Selection or Outside Selection
- Support for Parametrized Query / Saved Query with Parameters
- Tables Decoration / Manipulation
- Find / Replace Functionality (with support for regular expressions)
- Tabs Auto naming after query name (saved query, new query)
- Navigator: list of all BQ sessions across your PC
with quick info and ability to jump toSome Useful Links:
New BigQuery Session
Query Reference (Legacy SQL)
Query Reference (Standard SQL)
Google Cloud Status
Ask on Stack Overflow
BigQuery Mate on Trello
- Query Outline
- Extended Result Panel
- F5 to execute query + Ctrl-F5 to run selection
- Interactive Pivots / Charts of Query Result
- Search / Filter Recent Queries
- Tables Filtering
- Add All Fields to Query Editor, with or w/o alias
- Thousands separator for numeric fields
- Contextual Help via F1 or Right-Click Menu
- SQL Version Quick Switch (Click on SQL button or Alt-L) Recent!
- Save Default SQL Version (Double CLick on SQL button or Shift-Alt-L) Recent!
- Support for BigQuery Named Paramaters (@param). New!
Magnus style parameters still supported ()
- Keyboard Shortcuts to view previous/next page - Ctrl-ArrowLeft, Ctrl-ArrowRight
and first/last page - Ctrl-ArrowDown, Ctrl-ArrowUp
Warning: Google Team is constantly working on improving their BigQuery UI. Sometimes this breaks
features of the Tool. When this is a case, please calm down, stay tuned and check periorically
for extension updates. I am trying to fix issues as soon as they are introduced and I see them!